Dashboard 02 - Creating Cards and Slicer 17
In this step, we will create cards in the 2nd dashboard.
To help you get started, you can copy the following cards from Dashboard 01, RaleighPoliceIncidents, to this dashboard.
Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it.
Years
Violent Crime Rate
YOY Violent Crime Rate
Major Crime Rate
YOY Major Crime Rate
Select a District
Blank Text Box
Step 1: Create Crime Category Type Card
In Power BI Desktop, click on the page, RaleighPoliceIncidents-District
Click inside the pane
Click on the 'Select a District', press Ctrl+C to copy and Ctrl+V to paste it.
From the copied 'Select a District' card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Measure_Crime_Category
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Crime Category
Under Format -> General: X Position = 628 , Y Position = 108 , Width = 355 , Height = 36
Under Format -> Data Label -> Color = 094780 , Text Size = 19 pt , Font = DIN (default)
Under Format -> Category -> Set it to OFF
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = CCCCCC
Step 2: Create Violent Crime Rate Card
Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it.
From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_Violent_CrimeRate%
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Violent Crime Rate
Under Format -> General: X Position = 1 , Y Position = 167 , Width = 225 , Height = 160
Under Format -> Data Label -> Color = 000000 , Text Size = 28 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = 000000 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666
Step 3: Create Major Crime Rate Card
Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it.
From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_Major_CrimeRate%
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Major Crime Rate
Under Format -> General: X Position = 1 , Y Position = 604, Width = 225 , Height = 160
Under Format -> Data Label -> Color = 000000 , Text Size = 28 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = 000000 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666
Step 4: Create Year Over Year (YOY) Violent Crime Rate Card
Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it.
From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_Violent_Crimes_YOY%
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to YOY Violent Crime Rate
Under Format -> General: X Position = 1 , Y Position = 363 , Width = 225 , Height = 160
Under Format -> Data Label -> click fx
-> Format by = Color Scale, Based on Field =
.YOY_Violent_CrimeRate% , Minimum = 5B8F22 with a value of 0.00001 ,
Maximum = FF0000 with a value of 0 , Text Size = 28 pt , Font = DIN
(default)
Under Format -> Category -> Set it to ON -> Color = 000000 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666
Step 5: Create Year Over Year (YOY) Major Crime Rate Card
Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it.
From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Transparent_Major_Crimes_YOY%
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to YOY Major Crime Rate
Under Format -> General: X Position = 1 , Y Position = 787 , Width = 225 , Height = 160
Under Format -> Data Label -> click fx
-> Format by = Color Scale, Based on Field =
.YOY_Major_CrimeRate% , Minimum = 5B8F22 with a value of 0.00001 ,
Maximum = FF0000 with a value of 0 , Text Size = 28 pt , Font = DIN
(default)
Under Format -> Category -> Set it to ON -> Color = 000000 , Text Size = 15 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6
Under Format -> Border -> Set it to ON , Color = 666666
Step 6: Create Year Slicer
Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it.
From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:
Visualizations
Click the Slicer icon
Fields
Select the following:
Raleigh_Police_Incidents_NIBRS -> Reported_Date -> Date Hierarchy -> Year
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to YOY Major Crime Rate
Under Format -> General: X Position = 935 , Y Position = 0 , Width = 260 , Height = 108
Under Format -> Numeric Inputs -> Font Color = 000000, Text Size = 13 pt , Font = Segoe UI
Under Format -> Slider -> Set it to ON -> Color = 094780
Under
Format -> Title -> Set it to ON , Title Text = Years, Font Color
= 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size =
17 pt , Font Family = DIN (Default)
Under Format -> Border -> Set it to ON , Color = 666666
Step 07: Create Last Refreshed Card
Click inside the pane
Visualizations
Click the Card icon
Fields
Select the following:
A_KeyMeasures -> .Last_Refreshed_(Local)
Visualizations
Under Fields tab, click on the down arrow -> Rename for this visual and rename the card to Last Refreshed Date
Under Format -> General: X Position = 1 , Y Position = 65 , Width = 223 , Height = 80
Under Format -> Data Label -> Color = 094780 , Text Size = 17 pt , Font = DIN (default)
Under Format -> Category -> Set it to ON -> Color = 094780 , Text Size = 20 pt , Font = Segoe UI
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = E6E6E6Under Format -> Border -> Set it to ON , Color = 666666
Step 8 - Move the 'Select a District' card to the following position:
Under Format -> General: X Position = 983 , Y Position = 108 , Width = 417 , Height = 36
Step 9 - Move the Blank Text Box to the following position:
Under Format -> General: X Position = 225 , Y Position = 108 , Width = 355 , Height = 36
When finished, save the project.
How to create a Card visualization in Power BI